# --------------------------------------------------------Load Other Scripts----------------------------------------------------------------
#. ([System.IO.Path]::Combine((Split-Path $MyInvocation.MyCommand.Path),"output.ps1"));      
. $PSScriptRoot\configs.ps1 ;
# -------------------------------------------------------------Execute------------------------------------------------------------------------
#$deleteTemplate =  "DELETE FROM {0};" 
$modifyFieldDefualtValueTemplate = "ALTER TABLE {0} modify (SJHQBS default 1);";
$modifyCurrentFieldValueTemplate = "UPDATE {0} SET sjhqbs = 1;";
$selectCountTemplate =  "SELECT COUNT(1) FROM {0};";

<#
$sqls =@();
foreach ($tableName in $config_syncTables_ALLTABLES.Keys)
{
    $sqls += $selectCountTemplate -F $tableName.ToLower();
}

$sqls > c:/1.txt
#>

foreach ($tableName in $config_syncTables_ALLTABLES.Keys)
{
    $value = $config_syncTables_ALLTABLES[$tableName];
    if ($value.ContainsKey("BDCLX"))
    {
        Write-Host $tableName;
    }
}
